Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

Initial Programming Considerations

OpenEdge Studio used in conjunction with the DataServer allows you to develop applications that transparently access data from multiple sources. The OpenEdge DataServer for ORACLE achieves database transparency for applications running against OpenEdge and ORACLE, but some of the ways it accomplishes this might affect how you develop applications. This chapter discusses the differences between OpenEdge and ORACLE that you have to consider when you plan your applications and design your databases. In addition, your applications might have to accommodate the strategies that the DataServer uses to resolve these differences.

This chapter discusses equivalencies, differences, and strategies between ORACLE and OpenEdge, as detailed in the following sections:

Database design issues
Data types
Arrays
Unknown Value (?)
Record creation
Record locking
Transactions
Error handling
Cursors
Progress 4GL issues
RDBMS Stored Procedures